/**
 * Clean duplicate columns
 */
ALTER TABLE [dbo].[audits]
DROP COLUMN 
[iauditorapproved],
[iaduedate], 
[interimselectionmemoduedate],
[interimselectionmemoreceived],
[interimauditfirm],
[revisediadue],
[revisediareceived],
[revisediaapproved],
[revisedfinalauditreceived],
[revisedfaapproved],
[revisedfadue],
[interimauditmemonotes],
[finalauditorapproved],
[finalauditfirm],
[finalauditmemoresolution],
[datefinalauditdue],
[datefinalauditreceived]
GO